from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class LawSuitDetail(Base):
    __tablename__ = "TYC_JR_LAW_SUIT_DETAIL"
    JUDGEDATE = Column(String(255))
    JUDGERESULT = Column(Text)
    TITLE = Column(String(255))
    CASENO = Column(String(255))
    UUID = Column(String(255))
    COURTCONSIDER = Column(Text)
    COMPANIES = Column(Text)
    PLAINTIFFREQUEST = Column(Text)
    COURTINSPECT = Column(Text)
    TRIALPROCEDURE = Column(Text)
    LAWFIRMS = Column(Text)
    PLAINTIFFREQUESTOFFIRST = Column(Text)
    DEFENDANTREPLYOFFIRST = Column(Text)
    TRIALPERSON = Column(Text)
    PLAINTEXT = Column(Text)
    APPELLOR = Column(Text)
    COURT = Column(String(255))
    URL = Column(String(255))
    COURTCONSIDEROFFIRST = Column(Text)
    DOCTYPE = Column(String(255))
    TRIALASSISTPERSON = Column(String(255))
    CASETYPE = Column(String(255))
    APPELLANTREQUEST = Column(Text)
    DEFENDANTREPLY = Column(Text)
    COURTINSPECTOFFIRST = Column(Text)
    APPELLEEARGUING = Column(Text)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)